Icon

KNIME [UTM-Jtncpi] researcher impact

Node 1Node 21 staf akademik 050723Node 13Node 27Node 313 filter original book onlystatus,exc BE NGNode 85Bil grant per yearSort year descTotal PITotal PI 3 yrsstatus,author cat + 5yrs 2024-20201. joinercombined selected staf w masterlist pubNode 1332 amount approved2 filter Q1 Q2 only4 filter others pub onlycorr author3 Publication RADIS 3006232 grant 3006234 supervision 110723filter impactNode 209sponsor cat1 pi4. joiner4 svNode 216Node 217Node 218Node 219Node 220Node 221Node 225Node 226Node 227Node 228Node 229Node 230Node 232Node 235Node 236Node 237Node 238Node 239PI 5 yrsTotal PI 5 yrsPI 3 yrssv 5 yrSNode 244Node 245Node 246EXTRACT YEARSTART0622-0723COE L AND COE M ONLY5 GRANTNode 256status,exc BE NGfilter new end dateNode 259Node 260Node 261Node 262Node 263Node 264Node 265Node 267STAF AKADEMIKNode 414Node 415Node 416Node 417Node 588Node 589Node 590Node 591Node 5921 staf akademik 230424Node 5942 grant 2304243 Publication RADIS 2304244 supervision 230424sv 3 yrsstatus,author cat + 3yrs 2024-2022Node 600Node 601Node 602Node 603Node 604Node 6051 filter indexed onlyNode 607Node 608Node 6095 IPNode 6114. joinerip 5 yrSNode 6144 ipNode 616Node 6176 FOR NECstaf + summ grantstaf + summ grant + summ amtstaf + summ grant + summ amt + summ pubstaf + summ grant + summ amt + summ pub + summ svstaf + summ grant + summ amt + summ pub + summ sv + summ ipNode 624staf + summ grant + summ amt + summ pub + summ sv + summ ipNode 626Node 627Node 628active PIall + active PINode 631status,author cat + 5yrs 2024-2020Node 633Node 634Node 635Current PIEXTRACT YEARENDNode 638Node 639Node 640Node 641Node 642Node 643Node 645Node 646STAF AKADEMIKNode 648Node 649Node 650Node 651 Google Authenticator(Deprecated) Google SheetsConnector Google SheetsReader Pivot Pivot Column Aggregator Rule-basedRow Filter Rule-basedRow Filter String to Date&Time Pivot Column Resorter Column Aggregator Column Aggregator Rule-basedRow Filter Joiner Joiner Pivot Column Aggregator Rule-basedRow Filter Rule-basedRow Filter Column Aggregator Excel Reader Google SheetsReader Google SheetsReader Column Filter String to Date&Time Pivot Column Aggregator Joiner Pivot Column Filter Column Resorter Column Filter Column Resorter GroupBy GroupBy Column Aggregator Column Aggregator Joiner Joiner Joiner Column Filter Joiner Joiner Joiner Excel Writer Missing Value Column Filter Rule-basedRow Filter Column Aggregator Rule-basedRow Filter Rule-basedRow Filter Column Renamer Column Renamer Table Manipulator Date&Time PartExtractor Rule-basedRow Filter Rule-basedRow Filter DB Query Reader DB Connector Rule-basedRow Filter Rule-basedRow Filter Sorter Column Expressions Google Authenticator(Deprecated) Google SheetsConnector Google SheetsWriter GroupBy Sorter Rule-basedRow Filter DB Query Reader DuplicateRow Filter Sorter Rule-basedRow Filter GroupBy Group Loop Start Counter Generation Loop End(deprecated) Column Expressions Column Resorter DB Query Reader DB Connector DB Query Reader DB Query Reader DB Query Reader Rule-basedRow Filter Rule-basedRow Filter Column Expressions Google Authenticator(Deprecated) Google SheetsConnector Google SheetsWriter Missing Value Missing Value Rule-basedRow Filter Column Resorter Missing Value Missing Value DB Query Reader Rule-basedRow Filter Joiner Rule-basedRow Filter Date&Time PartExtractor Pivot Missing Value Column Filter DB Query Reader Joiner Joiner Joiner Joiner Joiner DuplicateRow Filter Joiner Column Resorter Missing Value Rule-basedRow Filter GroupBy Joiner Column Renamer Rule-basedRow Filter Column Filter Column Filter Rule-basedRow Filter Rule-basedRow Filter Date&Time PartExtractor Joiner Rule-basedRow Filter Excel Reader Rule-basedRow Filter DuplicateRow Filter Sorter Date&Time PartExtractor Rule-basedRow Filter DB Query Reader DuplicateRow Filter Sorter Concatenate Rule-basedRow Filter Node 1Node 21 staf akademik 050723Node 13Node 27Node 313 filter original book onlystatus,exc BE NGNode 85Bil grant per yearSort year descTotal PITotal PI 3 yrsstatus,author cat + 5yrs 2024-20201. joinercombined selected staf w masterlist pubNode 1332 amount approved2 filter Q1 Q2 only4 filter others pub onlycorr author3 Publication RADIS 3006232 grant 3006234 supervision 110723filter impactNode 209sponsor cat1 pi4. joiner4 svNode 216Node 217Node 218Node 219Node 220Node 221Node 225Node 226Node 227Node 228Node 229Node 230Node 232Node 235Node 236Node 237Node 238Node 239PI 5 yrsTotal PI 5 yrsPI 3 yrssv 5 yrSNode 244Node 245Node 246EXTRACT YEARSTART0622-0723COE L AND COE M ONLY5 GRANTNode 256status,exc BE NGfilter new end dateNode 259Node 260Node 261Node 262Node 263Node 264Node 265Node 267STAF AKADEMIKNode 414Node 415Node 416Node 417Node 588Node 589Node 590Node 591Node 5921 staf akademik 230424Node 5942 grant 2304243 Publication RADIS 2304244 supervision 230424sv 3 yrsstatus,author cat + 3yrs 2024-2022Node 600Node 601Node 602Node 603Node 604Node 6051 filter indexed onlyNode 607Node 608Node 6095 IPNode 6114. joinerip 5 yrSNode 6144 ipNode 616Node 6176 FOR NECstaf + summ grantstaf + summ grant + summ amtstaf + summ grant + summ amt + summ pubstaf + summ grant + summ amt + summ pub + summ svstaf + summ grant + summ amt + summ pub + summ sv + summ ipNode 624staf + summ grant + summ amt + summ pub + summ sv + summ ipNode 626Node 627Node 628active PIall + active PINode 631status,author cat + 5yrs 2024-2020Node 633Node 634Node 635Current PIEXTRACT YEARENDNode 638Node 639Node 640Node 641Node 642Node 643Node 645Node 646STAF AKADEMIKNode 648Node 649Node 650Node 651Google Authenticator(Deprecated) Google SheetsConnector Google SheetsReader Pivot Pivot Column Aggregator Rule-basedRow Filter Rule-basedRow Filter String to Date&Time Pivot Column Resorter Column Aggregator Column Aggregator Rule-basedRow Filter Joiner Joiner Pivot Column Aggregator Rule-basedRow Filter Rule-basedRow Filter Column Aggregator Excel Reader Google SheetsReader Google SheetsReader Column Filter String to Date&Time Pivot Column Aggregator Joiner Pivot Column Filter Column Resorter Column Filter Column Resorter GroupBy GroupBy Column Aggregator Column Aggregator Joiner Joiner Joiner Column Filter Joiner Joiner Joiner Excel Writer Missing Value Column Filter Rule-basedRow Filter Column Aggregator Rule-basedRow Filter Rule-basedRow Filter Column Renamer Column Renamer Table Manipulator Date&Time PartExtractor Rule-basedRow Filter Rule-basedRow Filter DB Query Reader DB Connector Rule-basedRow Filter Rule-basedRow Filter Sorter Column Expressions Google Authenticator(Deprecated) Google SheetsConnector Google SheetsWriter GroupBy Sorter Rule-basedRow Filter DB Query Reader DuplicateRow Filter Sorter Rule-basedRow Filter GroupBy Group Loop Start Counter Generation Loop End(deprecated) Column Expressions Column Resorter DB Query Reader DB Connector DB Query Reader DB Query Reader DB Query Reader Rule-basedRow Filter Rule-basedRow Filter Column Expressions Google Authenticator(Deprecated) Google SheetsConnector Google SheetsWriter Missing Value Missing Value Rule-basedRow Filter Column Resorter Missing Value Missing Value DB Query Reader Rule-basedRow Filter Joiner Rule-basedRow Filter Date&Time PartExtractor Pivot Missing Value Column Filter DB Query Reader Joiner Joiner Joiner Joiner Joiner DuplicateRow Filter Joiner Column Resorter Missing Value Rule-basedRow Filter GroupBy Joiner Column Renamer Rule-basedRow Filter Column Filter Column Filter Rule-basedRow Filter Rule-basedRow Filter Date&Time PartExtractor Joiner Rule-basedRow Filter Excel Reader Rule-basedRow Filter DuplicateRow Filter Sorter Date&Time PartExtractor Rule-basedRow Filter DB Query Reader DuplicateRow Filter Sorter Concatenate Rule-basedRow Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: NURIZA ANISA
Created at: 2023-07-12
On NodePit since: 2024-12-27
Last update: 2025-01-20
Created with KNIME version: v5.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!